# -*- coding: utf-8 -*-
"""
读写excel
"""

import pandas as pd
from pandas import DataFrame

# 读
df = pd.read_excel(r'test.xlsx', sheetname=0)



# 写
data={
'name':['张三','李四','王五'],
'age':[11,12,13],
'sex':['男','女','男'],
}
df=DataFrame(data)
df.to_excel('new.xlsx')






